﻿CREATE TABLE [dbo].[TariffProposals] (
    [Id]                 NVARCHAR (100) NOT NULL,
    [Date]               DATETIME       NOT NULL,
    [Title]              NVARCHAR (MAX) NOT NULL,
    [Type]               NVARCHAR (MAX) NOT NULL,
    [Summary]            NVARCHAR (MAX) NULL,
    [Link]               NVARCHAR (MAX) NOT NULL,
    [OriginatingChamber] NVARCHAR (MAX) NOT NULL,
    [ParliamentNumber]   INT            NOT NULL,
    [HTML]               NVARCHAR (MAX) NOT NULL,
    [IndexedContent]     NVARCHAR (MAX) NOT NULL,
    [DocumentPDFLink]    NVARCHAR (MAX) NULL,
    [DocumentWordLink]   NVARCHAR (MAX) NULL
);





